package com.jack.database_exp.mapper;
import com.jack.database_exp.bean.SellInfo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface SellInfoMapper {
    @Insert("insert into sellinfo (SNo,SINum,GNo,SIPrice) values(#{SNo},#{SINum},#{GNo},#{SIPrice})")
    public int insertInfo(SellInfo sellInfo);
    @Select("select * from sellinfo")
    public List<SellInfo> querySellInfos();
    @Select("select * from sellinfo where SNo = #{SNo}")
    public List<SellInfo> querySellInfoBySNo(Integer SNo);
}
